CREATE VIEW [Product Sales for 1997] AS 

SELECT  CategoryName, ProductName, 
Sum(Round(Ord_OrdDet.UnitPrice * Quantity * (1 - Discount), 2)) AS ProductSales, 
'Qtr ' || DatePart('q',[ShippedDate]) AS ShippedQuarter
FROM      (Categories 
                 INNER JOIN  
                 Products 
                 ON Categories.CategoryID = Products.CategoryID) 
            Cat_Prod 
            INNER JOIN 
                 (Orders 
                  INNER JOIN 
                  [Order Details] 
                  ON Orders.OrderID = [Order Details].OrderID) 
             Ord_OrdDet
             ON Cat_Prod.ProductID = Ord_OrdDet.ProductID
WHERE Ord_OrdDet.ShippedDate Between '1997-01-01 00:00:00' And '1997-12-31 00:00:00'
GROUP BY Cat_Prod.CategoryName, Cat_Prod.ProductName, DatePart('q',[ShippedDate])